Computer science

'

Answer using SQL statements

1)All information about rental with longest rental period. Rental period in days must appear.

2)How much money earned from rental by car manufacturer’s country every year.

3)Show 20% of our best customers by total income.

4)Show customers who used our rental 2 or more times and customer’s average money spending less than average rental price;

5)Show customer count by each state (for state show 2 letters abbreviation). Results sort by customer count descending order then by state abbreviation ascending;

6)Select car manufacturers in which cars were not maintained in 2008.